Workload-Aware Performance Tuning for Autonomous DBMSs

Optimal configuration is vital for a DataBase Management System (DBMS) to achieve high performance. There is no one-size-fits-all configuration that works for different workloads since each workload has varying patterns with different resource requirements. There is a relationship between configuration, workload, and system performance. If a configuration cannot adapt to the dynamic changes of a workload, there could be a significant degradation in the overall performance of DBMS unless a sophisticated administrator is continuously re-configuring the DBMS. In this tutorial, we focus on autonomous workload-aware performance tuning, which is expected to automatically and continuously tune the configuration as the workload changes. We survey three research directions, including 1) workload classification, 2) workload forecasting, and 3) workload-based tuning. While the first two topics address the issue of obtaining accurate workload information, the third one tackles the problem of how to properly use the workload information to optimize performance. We also identify research challenges and open problems, and give real-world examples about leveraging workload information for database tuning in commercial products (e.g., Amazon Redshift). We will demonstrate workload-aware performance tuning in Amazon Redshift in the presentation.Peer reviewe

Characteristic Test Analysis of Graphene Plus Optical Microfiber Coupler Combined Device and Its Application in Fiber Lasers

In this study, a graphene and optical microfiber coupler (OMC) integrated device (GOMC) was proposed and fabricated. After its characteristic analysis and testing, it was applied to the development of adjustable multi-wavelength fiber lasers. By integrating the OMC with graphene, the polarization dependence of OMC was enhanced. Meanwhile, the novel GOMC was given the capabilities of filtering, coupling, beam splitting, and polarization correlation. When the GOMC was integrated as a filter and beam splitter into the ring cavity of the fiber laser, the proposed GOMC-based fiber laser could achieve single-wavelength and multi-wavelength regulated output. The laser had a 3 dB linewidth of less than 30 pm, a signal-to-noise ratio of approximately 40 dB, and an output power fluctuation of less than 1 dB. The GOMC could also be used for the development of functional devices, such as adjustable mode lockers and mode coupling selectors, which provide an excellent experimental platform for new fiber lasers and the research of multi-dimensional light-field manipulation

SARS-CoV-2 Inactivation Simulation Using 14 MeV Neutron Irradiation

The SARS-CoV-2 virus is deadly, contagious, can cause COVID-19 disease, and endangers public health and safety. The development of SARS-CoV-2 inactivation technology is crucial and imminent in current pandemic period. Neutron radiation is usually used to sterilize viruses because neutron radiation is 10 times more effective than gamma-rays in inactivating viruses. In this work we established a closed SARS-CoV-2 inactivation container model by the Monte Carlo method and simulated the inactivation performance by using several different neutrons sources. To study the effects of inactivation container factors, including the reflector thickness, the type of the reflector material, the SARS-CoV-2 layer area and the distance from the radiation source on the energy deposition of a single neutron particle in SARS-CoV-2 sample, we simulated the neutron energy deposition on a SARS-CoV-2 sample. The simulation results indicate that the saturated thicknesses of reflector materials for graphite, water and paraffin are approximately 30 cm, 15 cm, and 10 cm, respectively, and the energy deposition (radiation dose) becomes larger when the SARS-CoV-2 layer area is smaller and the SARS-CoV-2 layer is placed closer to the neutron source. The calculated single-neutron energy deposition on 10 × 10 cm2 SARS-CoV-2 layer is about 3.0059 × 10−4 MeV/g with graphite as the reflection layer, when the 14 MeV neutron source intensity is 1012 n/s and the SARS-CoV-2 layer is 5 cm away from the neutron source. If the lethal dose of SARS-CoV-2 is assumed as the IAEA recommended reference dose, 25 kGy, the SARS-CoV-2 could be decontaminated in about 87 min, and the sterilization time could be less than 52 s if the 14 MeV neutron intensity is increased to 1014 n/s